Microsoft Excel Pivot Table Data Crunching (Office 2021 and Microsoft 365) by Bill Jelen

Author:Bill Jelen [Bill Jelen]
Language: eng
Format: epub
Publisher: Microsoft Press
Published: 2021-12-27T16:00:00+00:00

FIGURE 9-40 Enabling what-if analysis allows you to change the values in a pivot table.

At this point, you can edit the values in your pivot table. After you have made changes, you can right-click any of the changed values and choose Calculate PivotTable With Change (see Figure 9-41). This forces Excel to reevaluate all the calculations in the pivot table based on your edits—including your calculated members and measures.

FIGURE 9-41 Choose Calculate PivotTable With Change to reevaluate all your calculations.

The edits you make to your pivot table while using what-if analysis are, by default, local edits only. If you are committed to your changes and would like to actually make the changes on the OLAP server, you can tell Excel to publish your changes. To do this, in the PivotTable Analyze tab, select What-If Analysis, Publish Changes (see Figure 9-42). This triggers a “write-back” to the OLAP server, meaning the edited values are sent to the source OLAP cube.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.